The Database API > Database API functions > MMDB.getColumnAndTypeList() |
![]() ![]() ![]() |
Availability
Dreamweaver UltraDev 1.0
Description
Gets a list of columns and their types from an executed SQL SELECT
statement.
Arguments
connName
,
statement
![]() |
connName is the UltraDev connection name as specified in the Connection Manager. It is used to make a database connection to a live data source. |
![]() |
statement is the SQL SELECT statement to execute. |
Returns
An array of strings representing a list of columns (and their types) that match the SELECT
statement, or an error if the SQL statement was invalid or the connection could not be made.
Example
The code var columnArray = MMDB.getColumnAndTypeList("EmpDB","Select * from Employees")
returns the following array of strings:
columnArray[0] = "EmpName" , columnArray[1] = "varchar", ¬ columnArray[2] = "EmpFirstName", columnArray[3] = "varchar", ¬ columnArray[4] = "Age", columnArray[5] = "integer"
![]() ![]() ![]() |